2015-07-06 - 19783.200 - BreakFix - Pay115 Report trade discrepancy #CrystalReportsSupport
BreakFix
19783.200 - PAY115
Problem Summary
Need to modify the formulas in PAY115 report to correct the trade percentage.
Admin Info
Purpose
|
Need to modify the formulas in PAY115 report to correct the trade percentage.
|
Requested by
|
Dawn Whalen
|
Issue Date
|
07-06-2015
|
Resolved by
|
Venkateswara Reddy D
|
Resolved Date
|
07-31-2015
|
Document Status
|
WIP
|
Detailed Problem Description
(Include Screen Shots if required )
PAY115 crystal report has trade discrepancy compared to the POLCA application. The percentage is calculating correctly in the application, but the report is not. Formulas in crystal need to be modified to complete the same functions as the application
Solution Analysis and Recommendations
(Include Screen Shots if required)
1) Need to analyze the formulas in the report.
2) Need to change the logic in the "Base Rate NW" formula
Resolution
1) Need to analyze the formulas in the report.
2) Need to change the logic in the "Base Rate NW" formula
BaseRateNW
If {Command.NEC_FLOATER_EMP} = 'Y' then
(
IF {Command.NEC_LAST_HIRE_DT}<= date('05/05/2006') then {Command.NEC_NEW_FL_BASE_RT}
ELSE IF {Command.NEC_LAST_HIRE_DT} > date('05/05/2006') and {Command.NEC_NEW_HIRE_DATE} <= date('05/02/2010') then {Command.NEC_FL_BASE_RT}
ELSE IF {Command.NEC_LAST_HIRE_DT} > date('05/02/2010') then {Command.NEC_T3_FL_BASE_RT}
ELSE 0
)
ELSE IF {Command.NEC_LAST_HIRE_DT} <= date('05/05/2006') then {Command.NEC_BASE_RATE}
ELSE IF {Command.NEC_LAST_HIRE_DT} > date('05/05/2006') and {Command.NEC_NEW_HIRE_DATE} <= date('05/02/2010') then {Command.NEC_T3_BASE_RATE}
ELSE IF {Command.NEC_NEW_HIRE_DATE} > date('05/02/2010') then {Command.NEC_NEW_BASE_RATE}
ELSE 0
3) Need to create new formula to get the trade hours based on the trade.
IF {Command.trade} = 'Y'
then {Command.Trade Hrs}
else
0
4) Need to updating all formatting changes based on NEC standards.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
|
|
|
Release Information
None